package com.fengchao.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * Created by http://my.oschina.net/wangnian on 2016/7/18.
 */
@Mapper
public interface SvyUserWishRequestMapper {

    @Select("select wish_artist_id as wishArtistId, wish_city_id as wishCicyId, COUNT(wish_artist_id) as count from svy_user_wish_request GROUP BY wish_artist_id, wish_city_id;")
    List<Map<String, Object>> statistics();
}
